﻿<cfsilent>
	<cfscript>
		
		jsonAdvice = getProperty("serviceFactory").getBean("jsonAdvice");
		response = structNew();
		
		subjectId = event.getArg("SubjectID");
		transaction {
			sql = "DELETE FROM t_subject 
							WHERE sbj_id = :SubjectID ";
			queryObj = new query( datasource=application.dnsMaster );
			queryObj.addParam( name="SubjectID", value=subjectId, cfsqltype="cf_sql_varchar" );
			queryObj.execute( sql=sql );
		}
		structInsert(response, "SubjectID", subjectId);
		
	</cfscript>	
</cfsilent><cfoutput>#jsonAdvice.encode(data:response, stringNumbers:true)#</cfoutput>